Skip to main content

Following steps to create dataset using Excel

  • From this document, you will learn to create a dataset in OPNBI, Moreover, you will learn to make a dataset using EXCEL. It provides the facility to add & use the user required data in OPNBI.

What is Excel?

  • Excel is a spreadsheet program available in the Microsoft Office Package. MS Excel is used to create Worksheets (spreadsheets) to store and organize data in a table format.
info

Click here to know more about Excel.

Objectives

  • Create Dataset using Excel

Prerequisites

  • For this example we are using worldcities.xlxs

Download excel.zip file from link given excel.zip

  • After downloading the zip file, add it into the OPNBI. To add it into OPNBI follow this Link.

Skill Level Required

  • Basic knowledge of Excel

Steps to create dataset using Excel

  1. Click on Hamburger Icon & go to Documents Tab.

    Docusaurus Slash Introduction

  2. In Documents tab Click on Shared Resource.

  3. In Shared Resource Click on upload, As shown in figure below:

    Docusaurus Slash Introduction

  4. When you click on Upload it will display a screen.

  5. In Upload Files upload a worldcities Excel file, As shown in figure below:

    Docusaurus Slash Introduction

  • User will find excel.zip from the start of this document. Use worldcities excel file from that zip .
  1. Click on Upload button.

  2. You will get a message, As shown in figure below:

    Docusaurus Slash Introduction

  3. Go to Hamburger menu > In Master Data Tab click on Dataset.

    Docusaurus Slash Introduction

  4. Click on create dataset, As shown in figure below:

    Docusaurus Slash Introduction

  5. Enter following details in Create Dataset.

  • Name: World Cities
  • Datasource: Existing Files
  • Select Excel Radio Button
  • Select World Cities.ds file in Available to selected.
  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on Preview and submit button.

  3. You will see the World Cities.ds Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  4. Click on Dashboard Tab and open Dashboard.

  5. From Right Vertical Menu Select the Table Widget icon. (User can select any widget from the vertical menu list as required)

info
  • Click here to know more about different dashboard widgets.
  1. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  2. Enter Following Details in edit box, As shown in figure below:

  • Dataset: World Cities.ds
  • Select all the Field in Dataset Column.
  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on Preview and Save and Exit.

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    Docusaurus Slash Introduction

To know more about how to create dataset using different sources follow below Links:-

Dataset using CSV

Dataset using JSON

Dataset using Flatfiles

Dataset using External sources

Dataset using Google BigQuery

Dataset using noSQL

Dataset using Join

Dataset using Union

Dataset using Server Script

Dataset using Client Script

Dataset using Stored Procedure

Dataset using View

Dataset using Simple Query

Dataset using Drag & Drop